<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>系统数据查询</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1" name="viewport">
<meta content="" name="description">
<meta content="" name="author">
<link href="${request.getContextPath()}/Public/assets/admin/css/css.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/font-awesome/css/font-awesome.min.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/simple-line-icons/simple-line-icons.min.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/bootstrap/css/bootstrap.min.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/uniform/css/uniform.default.css"
	rel="stylesheet" type="text/css">

<link
	href="${request.getContextPath()}/Public/assets/global/css/components-rounded.css"
	id="style_components" rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/css/plugins.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/admin/css/layout.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/admin/css/themes/default.css"
	rel="stylesheet" type="text/css" id="style_color">
<link
	href="${request.getContextPath()}/Public/assets/admin/css/custom.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css"
	rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css"
	href="${request.getContextPath()}/Public/assets/global/plugins/jquery-notific8/jquery.notific8.min.css" />
<link
	href="${request.getContextPath()}/Public/assets/admin/css/common.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/css/kkpager.css"
	rel="stylesheet" type="text/css">
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/fancybox/source/jquery.fancybox.css"
	rel="stylesheet" type="text/css" />
<link rel="shortcut icon"
	href="${request.getContextPath()}/Public/favicon.ico">

<!-- select2控件样式 -->
<link
	href="${request.getContextPath()}/Public/assets/global/plugins/select2/select2.css"
	rel="stylesheet" type="text/css">
<script>
	BASE_URL = '${request.getContextPath()}'
</script>
<style type="text/css">

.nav> li > a {
    text-shadow: none;
    color: red;
    font-size: 22px;
}
.datepicker {
	font-size: 16px;
}

.datepicker td, .datepicker th {
	width: 14.28571428571429%;
	height: 40px;
}

.table-condensed {
	width: 100%;
}

.datepicker-inline {
	width: 100%;
}

.col-md-4, .col-md-6, .col-md-7, .col-md-12 {
	padding-right: 0px;
	padding-left: 0px;
}

.table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th,
	.table>thead>tr>td, .table>thead>tr>th {
	border-bottom: 1px solid #ddd;
}
.input-inline {
    display: inline-block;
    width: 315px;
    vertical-align: middle;
}

.nav-tabs>li.active>a, .nav-tabs>li.active>a:focus, .nav-tabs>li.active>a:hover{
    color: #EF0E0E;
    cursor: default;
    background-color: #fff;
    border: 1px solid #ddd;
    border-bottom-color: transparent;
}
.nav>li>a{
	text-shadow: none;
    color: rgb(45, 41, 41);
    font-size: 15px;
}

/* .navbar-default {
    background-color: #CC5252;
    border-color: #522121;
} */

</style>

</head>
<body class="page-header-top-fixed page-footer-fixed">
	<!--头部信息结束 -->
	<div class="page-header">
		<!--头部开始-->
		<#include "/include/top.html" />
		<!-- 头部信息结束 -->
	</div>
	
	<!-- BEGIN PAGE CONTAINER -->
	<div class="page-container">
		<#include "/include/menu.html" />
		<div class="page-content-wrapper">
			<div class="page-content">
				<div class="container-fluid">
				<div class="row">
					<div class="col-md-12">
						<div class="portlet light " style="margin-top: 5px;">
							<div class="portlet-body">
									<div class="row" style="height: 56px; text-align:left ;padding-left: 3px;">
										<div class="col-sm-12">
											<div id="sample_2_filter" class="dataTables_filter">
												<form action="${request.getContextPath()}/capitalData/systemDataQuery.do" method="post" id="myForm">

														<label>
															企业名称:<input type="text" class="form-control input-small2  input-inline" placeholder="企业名称" name="companyName" id="companyName" value="${search.companyName!''}">
														</label>
														<label>
															企业邮箱:<input type="search" class="form-control input-small2  input-inline" placeholder="企业邮箱" name="companyMail" id="companyMail" value="${search.companyMail!''}">
														</label>
							
														<label>
															日期:
															&nbsp;<input class="form-control input-small2  input-inline" type="search" placeholder="开始时间" name="startTrDate" id="startTrDate" value="${search.startTrDate}" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})">
															
														</label>
																-
														<label>
																<input class="form-control input-small2  input-inline" type="search" placeholder="结束时间" name="endTrDate" id="endTrDate" value="${search.endTrDate}" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})">
														</label>
							
												
							
														<label>
															<select class="form-control input-small2 input-inline" name="selectConditions"  id="selectConditions">
																<option value="1"  <#if search.selectConditions?? && search.selectConditions=="1"> selected="selected" </#if>>可用余额</option>
																<option value="2" <#if search.selectConditions?? && search.selectConditions=="2"> selected="selected" </#if>>账户总余额</option>
																<option value="3" <#if search.selectConditions?? && search.selectConditions=="3"> selected="selected" </#if>>单笔出金</option>
																<option value="4" <#if search.selectConditions?? && search.selectConditions=="4"> selected="selected" </#if>>单笔入金</option>
																<option value="5" <#if search.selectConditions?? && search.selectConditions=="5"> selected="selected" </#if>>冻结资金</option>
															</select>
														</label>
														<label>
															<select class="form-control input-small input-inline" name="startOperator">
																<option value=">"<#if search.startOperator?? && search.startOperator==">"> selected="selected" </#if>>大于</option>
																<option value="<"  
																				<#if search.startOperator==null||search.startOperator=="<"> selected="selected" </#if>>小于</option>
																<option value="="  	<#if search.startOperator?? && search.startOperator=="="> selected="selected" </#if> >等于</option>
															</select>
														</label>
														<label>
															<input type="search" class="form-control input-small input-inline" name="startValue" id="startValue" value="${search.startValue}">
														</label>
														<label>
															<select class="form-control input-small input-inline" name="endOperator"  id="endOperator" >
																<option value=">"<#if search.endOperator?? && search.endOperator==">"> selected="selected" </#if>>大于</option>
																<option value="<"  
																				<#if search.endOperator==null||search.endOperator=="<"> selected="selected" </#if>>小于</option>
																<option value="="  	<#if search.endOperator?? && search.endOperator=="="> selected="selected" </#if> >等于</option>
															</select>
														</label>
														
														<label>
															<input type="search" class="form-control input-small input-inline" name="endValue"  id="endValue" value="${search.endValue}">
														</label>

														
													<button  class="btn red"  type="submit" >
														<i class="fa fa-search"></i> 搜索
													</button>
													<a  class="btn red"   onclick="preview(1)">
														<i class="fa fa-print"></i> 打印
													</a>
													<a  class="btn red"  onclick="dataExport()">
														<i class="fa fa-file-excel-o"></i> 导出
													</a>
												
							
												</form>
											</div>
										</div>
									</div>
									<div  id="tabledata">
									<table class="table table-striped table-hover">
									<thead>
									<tr>
									
										<th>
											日期
										</th>
										<th>
											交易备注
										</th>
										<th>
											 企业名称<br>
											 (企业附属账号)
										</th>
										<th>
											对方企业
										</th>
	
										<th>
											借
										</th>
										<th>
											贷
										</th>										
										<th>
											冻结金额
										</th>
										<th>
											帐户总余额
										</th>
									</tr>
									</thead>
										<tbody id="tbodyList">
										
										<#list listMap as lm>
											<tr>
												<td>${lm.trDate!""}</td>
												<td>${lm.note!""}</td>
												<td>${lm.companyName!""}<br>
													${lm.userAccountNo!""}
												</td>
												<td>${lm.oppositCompanyName!""}</td>
												<td>
													<#if lm.borrow ??>
														${lm.borrow?string(',###.##')}
													</#if>
												</td> 
												<td>
													<#if lm.loan ??>
														${lm.loan?string(',###.##')}
													</#if>
												</td> 
												<td>
													<#if lm.freezeMoney ??>
														${lm.freezeMoney?string(',###.##')}
													</#if>
												</td>
												<td>
													<#if lm.totalMoney ??>
														${lm.totalMoney?string(',###.##')}
													</#if>
												</td>
											</tr>
										</#list>
										
										</tbody>
									</table>
									</div>
									
									
									
									
									<div style="width:80%;margin:0 auto;">
										<div id="kkpager">
											<input type="hidden" value="${totalPage!''}" id="totalPage">
											<input type="hidden" value="${totalRecords!''}" id="totalRecords">
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	
	
	
	<!-- END PAGE CONTAINER -->
	<!-- 底部开始 -->
	<#include "/include/foot.html" />
	<!-- 底部结束 -->
</body>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery-migrate.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery-ui/jquery-ui.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/bootstrap/js/bootstrap.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery.blockui.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery.cokie.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/uniform/jquery.uniform.min.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery-notific8/jquery.notific8.min.js"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/jquery.sparkline.min.js"
	type="text/javascript"></script>

<script
	src="${request.getContextPath()}/Public/assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker-index.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/fancybox/source/jquery.fancybox.pack.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/scripts/metronic.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/admin/scripts/layout.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/admin/scripts/commonUtils.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/highcharts.js"
	type="text/javascript"></script>
<script
	src="${request.getContextPath()}/Public/assets/global/plugins/kkpager.min.js"
	type="text/javascript"></script>
<script type="text/javascript"
	src="${request.getContextPath()}/Public/My97DatePicker/WdatePicker.js"></script>
<script src="${request.getContextPath()}/Public/js/moment/moment.js"
	type="text/javascript"></script>


<!-- select2控件 -->
<script type="text/javascript"
	src="${request.getContextPath()}/Public/assets/global/plugins/select2/select2.js"></script>
<script type="text/javascript"
	src="${request.getContextPath()}/Public/assets/global/plugins/select2/select2_locale_zh-CN.js"></script>
	
<!-- 脚本代码 -->
<script type="text/javascript">
	$(function() {
		Metronic.init(); // init metronic core componets
		Layout.init(); // init layout
		
		//搜索下拉框
		//toSelect2();
		
		//初始化分页插件	
		toPage();
	});

	//分页
	function toPage(){
		function getParameter(name) {
			var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)");
			var r = window.location.search.substr(1).match(reg);
			if (r != null)
				return unescape(r[2]);
			return null;
		}
		
		var totalPage = $('#totalPage').val();
		var totalRecords = $('#totalRecords').val();
	
		var pageNo = getParameter('pno');
		if (!pageNo) {
			pageNo = 1;
		}
		
		//生成分页
		//有些参数是可选的，比如lang，若不传有默认值
		kkpager.generPageHtml({
			pno : pageNo,
			//总页码
			total : totalPage,
			//总数据条数
			totalRecords : totalRecords,
	
			getLink : function(n) {

				return this.hrefFormer + this.hrefLatter + "?pno=" + n+"&companyName="+$("#companyName").val()+"&companyMail="+$("#companyMail").val()+
						"&startTrDate="+$("#startTrDate").val()+"&endTrDate="+$("#endTrDate").val()+"&selectConditions="+$("#selectConditions").val()+"&startOperator="+$("#startOperator").val()+
						"&startValue="+$("#startValue").val()+"&endOperator="+$("#endOperator").val()+"&endValue="+$("#endValue").val();
			}
		});
	}


	
	



	
	function preview(oper)
	{
		if (oper < 10){
			bdhtml=window.document.body.innerHTML;//获取当前页的html代码
/* 			sprnstr="<!--startprint"+oper+"-->";//设置打印开始区域
			eprnstr="<!--endprint"+oper+"-->";//设置打印结束区域
			prnhtml=bdhtml.substring(bdhtml.indexOf(sprnstr)+18); //从开始代码向后取html
		
			prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));//从结束代码向前取html */
			window.document.body.innerHTML=$("#tabledata").html();
			window.print();
			window.document.body.innerHTML=bdhtml;
		} else {
			window.print();
		}

	}
	// 导出
	function dataExport(){
		var oldAction=$("#myForm").attr("action");
		$("#myForm").attr("action","${request.getContextPath()}/capitalData/systemDataExport.do");
		$("#myForm").submit();
		$("#myForm").attr("action",oldAction);
	}
	

	
</script>
</html>